/**
 * @Author liuhaijin
 * @Date 2022/2/24
 */
package xyz.haijin.zt.mysql.constant;

/**
 * 查询常量
 * @author liuhaijin
 * @date 2022-02-24
 */
public interface QueryConstant {
    String AND = "and"; // 和
    String OR = "or";   // 或
    String NESTED = "nested"; // 嵌套
    String EQ = "eq"; //等于
    String NE = "ne"; //不等于
    String GT = "gt"; //大于
    String GE = "ge"; //大于等于
    String LT = "lt"; //小于
    String LE = "le"; //小于等于
    String BETWEEN = "between"; // 在...之间
    String NOT_BETWEEN = "notBetween"; // 不在...之间
    String LIKE = "like"; // 模糊查询
    String NOT_LIKE = "notLike"; // 非模糊查询
    String LIKE_LEFT = "likeLeft"; // 左模糊
    String LIKE_RIGHT = "likeRight"; // 右模糊查询
    String IN = "in"; // 选择查询
    String NOT_IN = "notIn"; // 非选择查询
    String IS_NULL = "isNull"; // 为空
    String IS_NOT_NULL = "isNotNull"; // 不为空
    String CONTAIN_ARRAY = "contain"; // 包含
    String CONTAINED_BY_ARRAY = "contained_by";  // 被包含
    String OVERLAP_ARRAY = "overlap"; // 重叠
    String ASC = "asc"; // 正序
    String DESC = "desc"; // 倒序
    String DATE = "date"; // 日期
    String TIMESTAMP = "timestamp"; // 时间戳
}
